********************************************************************************
******"Macroprudential Regulation, Quantitative Easing, and Bank Lending"*******
********************************************************************************
global y "lncdisbur_w199"
global regcommands ", pool(5) compact absorb(bankid borrowerid#time) vce(cluster bankid)"

clear *
**# Bookmark (input)
import sas ENTE_SEGN CENSITO_CRITTOG TIME DISBUR COM COMUNE_DIP using $inputdirectory/bloans, case(lower)
run RO_creditregister tm(2014m6) tm(2015m6) 0
keep bankid borrowerid time disbur

**# Bookmark (input)
merge m:1 bankid using $inputdirectory/INB_gru2015, keepus(gru)
keep if _merge!=2
drop _merge
replace gru=bankid if gru==.
drop bankid
rename gru bankid
collapse (sum) disbur, by(bankid borrowerid time)

**# Bookmark (input)
merge m:1 bankid using $inputdirectory/INB_preann2014m12, keepus(dtop85e13 exlnassets excashas ext1r)
keep if _merge==3
drop _merge

**# Bookmark (input)
merge m:1 bankid time using $inputdirectory/INB_refinm2015, keepus(lncrefin)
keep if _merge!=2
drop _merge

egen id=group(bankid borrowerid)
xtset id time
gen lncdisbur=100*(ln(disbur)-ln(L.disbur))
keep if time>=tm(2014m7)&time<=tm(2015m6)
winsor2 lncdisbur if lncdisbur!=., suffix(_w199) cuts(1 99)

**# Bookmark (input)
merge m:1 bankid time using $inputdirectory/INB_CGP32015, keepus(cgasover)
keep if _merge!=2
drop _merge
recode cgasover (.=0)

**# Bookmark (input)
merge m:1 bankid time using $inputdirectory/INB_TP22015, keepus(tradingover)
keep if _merge!=2
drop _merge
recode tradingover (.=0)
rename tradingover tradingoverAFS

**# Bookmark (input)
merge m:1 bankid time using $inputdirectory/INB_TP32015, keepus(tradingover)
keep if _merge!=2
drop _merge
recode tradingover (.=0)
rename tradingover tradingoverTB

**# Bookmark (input)
merge m:1 bankid time using $inputdirectory/INB_TP32ALL2015, keepus(tradingover)
keep if _merge!=2
drop _merge
recode tradingover (.=0)
rename tradingover tradingoverALL

**# Bookmark (input)
merge m:1 bankid time using $inputdirectory/INB_TP322015, keepus(tradingover)
keep if _merge!=2
drop _merge
recode tradingover (.=0)
rename tradingover tradingoverAFSTB

gen bcapacityover=cgasover/(ext1r/100)

run RO_tdummies 2015 1
run RO_tdintera 1 "exlnassets excashas cgasover bcapacityover tradingoverAFS tradingoverTB tradingoverALL tradingoverAFSTB"

**# Bookmark (output - columns 1-2-3-4)
cd $outputdirectory
est clear
reghdfe $y dT7cgasover dT7tradingoverAFS dT7exlnassets dT7excashas lncrefin $regcommands
est save TABIIIE_C1234
reghdfe $y dT7cgasover dT7tradingoverTB dT7exlnassets dT7excashas lncrefin $regcommands
est save TABIIIE_C1234, append
reghdfe $y dT7cgasover dT7tradingoverALL dT7exlnassets dT7excashas lncrefin $regcommands
est save TABIIIE_C1234, append
reghdfe $y dT7bcapacityover dT7tradingoverAFSTB dT7exlnassets dT7excashas lncrefin $regcommands
est save TABIIIE_C1234, append
cd ..
